<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE topic
  PUBLIC "-//OASIS//DTD DITA Composite//EN" "ditabase.dtd">
<topic id="topic1" xml:lang="en">
  <title id="fs142834">foreign_servers</title>
  <body>
    <p>The <codeph>foreign_servers</codeph> view contains all foreign servers  defined
      in the current database. Greenplum Database displays only those foreign servers to
       which the current user has access (by way of being the owner or having some privilege).</p>
    <table id="fs142842">
      <title>foreign_servers</title>
      <tgroup cols="4">
        <colspec colnum="1" colname="col1" colwidth="131pt"/>
        <colspec colnum="2" colname="col2" colwidth="73pt"/>
        <colspec colnum="3" colname="col3" colwidth="101pt"/>
        <colspec colnum="4" colname="col4" colwidth="145pt"/>
        <thead>
          <row>
            <entry colname="col1">column</entry>
            <entry colname="col2">type</entry>
            <entry colname="col3">references</entry>
            <entry colname="col4">description</entry>
          </row>
        </thead>
        <tbody>
          <row>
            <entry colname="col1">
              <codeph>foreign_server_catalog</codeph>
            </entry>
            <entry colname="col2">sql_identifier</entry>
            <entry colname="col3"></entry>
            <entry colname="col4">Name of the database in which the foreign server
              is defined (always the current database).</entry>
          </row>
          <row>
            <entry colname="col1">
              <codeph>foreign_server_name</codeph>
            </entry>
            <entry colname="col2">sql_identifier</entry>
            <entry colname="col3"></entry>
            <entry colname="col4">Name of the foreign server.</entry>
          </row>
          <row>
            <entry colname="col1">
              <codeph>foreign_data_wrapper_catalog</codeph>
            </entry>
            <entry colname="col2">sql_identifier</entry>
            <entry colname="col3"></entry>
            <entry colname="col4">Name of the database in which the foreign-data wrapper
              used by the foreign server is defined (always the current database).</entry>
          </row>
          <row>
            <entry colname="col1">
              <codeph>foreign_data_wrapper_name</codeph>
            </entry>
            <entry colname="col2">sql_identifier</entry>
            <entry colname="col3"></entry>
            <entry colname="col4">Name of the foreign-data wrapper used by the foreign server.</entry>
          </row>
          <row>
            <entry colname="col1">
              <codeph>foreign_server_type</codeph>
            </entry>
            <entry colname="col2">character_data</entry>
            <entry colname="col3"/>
            <entry colname="col4">Foreign server type information, if specified upon creation.</entry>
          </row>
          <row>
            <entry colname="col1">
              <codeph>foreign_server_version</codeph>
            </entry>
            <entry colname="col2">character_data</entry>
            <entry colname="col3"/>
            <entry colname="col4">Foreign server version information, if specified upon creation.</entry>
          </row>
          <row>
            <entry colname="col1">
              <codeph>authorization_identifier</codeph>
            </entry>
            <entry colname="col2">sql_identifier</entry>
            <entry colname="col3"/>
            <entry colname="col4">Name of the owner of the foreign server.</entry>
          </row>
        </tbody>
      </tgroup>
    </table>
  </body>
</topic>
